use BanSach
create proc nhanvien_them
@manv nvarchar(200),
@tennv nvarchar(200),
@diachi nvarchar(200)
as
begin 
insert into NhanVien values(@manv,@tennv,@diachi)
end
go
create proc nhanvien_sua
@manv nvarchar(200),
@tennv nvarchar(200),
@diachi nvarchar(200)
as
begin
update NhanVien set MaNV =@manv,TenNV = @tennv,DiaChi = @diachi where MaNV =@manv
end
go
create proc  nhanvien_xem
@manv nvarchar(200),
@tennv nvarchar(200),
@diachi nvarchar(200)
as
begin
select * from NhanVien where MaNV = @manv
end
go
create proc nhanvien__xoa
@manv nvarchar(200)
as
begin
delete from NhanVien where MaNV = @manv
end
go